/**
 * 数据库信息
 */
<template>
  <div>
    <!-- 面包屑导航 -->
    <el-breadcrumb separator-class="el-icon-arrow-right">
      <el-breadcrumb-item :to="{ path: '/' }">首页</el-breadcrumb-item>
      <el-breadcrumb-item>数据库信息</el-breadcrumb-item>
    </el-breadcrumb>
    <!-- 搜索筛选 -->
    <el-form :inline="true" :model="formInline" class="user-search">
      <el-form-item label="搜索：">
        <el-input
          size="small"
          v-model="formInline.roleName"
          placeholder="输入申请单号"
        ></el-input>
      </el-form-item>
      <el-form-item>
        <el-button
          size="small"
          type="primary"
          icon="el-icon-search"
          @click="search"
          >搜索</el-button
        >
        <el-button
          size="small"
          type="primary"
          icon="el-icon-plus"
          @click="handleEdit()"
          >添加</el-button
        >
      </el-form-item>
    </el-form>
    <!--列表-->
    <el-table
      size="small"
      :data="listData"
      highlight-current-row
      v-loading="loading"
      border
      element-loading-text="拼命加载中"
      style="width: 100%"
    >
      <el-table-column align="center" type="selection" width="60">
      </el-table-column>
      <el-table-column sortable prop="roleName" label="申请单号" width="100">
      </el-table-column>
      <el-table-column
        sortable
        prop="roleNo"
        label="申请数据库类型"
        width="150"
      >
      </el-table-column>
      <el-table-column
        sortable
        prop="editTime"
        label="业务系统名称"
        width="120"
      >
      </el-table-column>
      <el-table-column sortable prop="editUser" label="数据库名" width="120">
      </el-table-column>
      <el-table-column sortable prop="editUser" label="用户名" width="200">
      </el-table-column>
      <el-table-column
        sortable
        prop="editUser"
        label="预计使用存储量"
        width="150"
      >
      </el-table-column>
      <el-table-column sortable prop="editUser" label="附件" width="120">
      </el-table-column>
      <el-table-column align="center" label="操作" min-width="200">
        <template slot-scope="scope">
          <el-button size="mini" @click="handleEdit(scope.$index, scope.row)"
            >编辑</el-button
          >
          <el-button
            size="mini"
            type="danger"
            @click="deleteUser(scope.$index, scope.row)"
            >删除</el-button
          >
        </template>
      </el-table-column>
    </el-table>
    <!-- 分页组件 -->
    <Pagination
      v-bind:child-msg="pageparm"
      @callFather="callFather"
    ></Pagination>
    <!-- 编辑界面 -->
    <el-dialog
      :title="title"
      :visible.sync="editFormVisible"
      width="70%"
      @click="closeDialog('edit')"
    >
      <el-form
        label-width="130px"
        :model="editForm"
        ref="editForm"
        :rules="rules"
      >
        <!-- <div class="form-title">租户基本信息</div> -->
        <el-row>
          <el-col :span="12">
            <el-form-item label="申请单号" prop="requestNo">
              <el-input
                size="small"
                v-model="editForm.requestNo"
                auto-complete="off"
                placeholder="请输入申请单号"
              ></el-input>
            </el-form-item>
          </el-col>
          <el-col :span="12">
            <el-form-item label="申请数据库类型" prop="databaseType">
              <el-input
                size="small"
                v-model="editForm.databaseType"
                auto-complete="off"
                placeholder="请输入申请数据库类型"
              ></el-input>
            </el-form-item>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="12">
            <el-form-item label="业务系统名称" prop="businessSystemName">
              <el-input
                size="small"
                v-model="editForm.businessSystemName"
                auto-complete="off"
                placeholder="请输入业务系统名称"
              ></el-input>
            </el-form-item>
          </el-col>
          <el-col :span="12">
            <el-form-item label="数据库名" prop="databaseName">
              <el-input
                size="small"
                v-model="editForm.databaseName"
                auto-complete="off"
                placeholder="请输入数据库名"
              ></el-input>
            </el-form-item>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="12">
            <el-form-item label="用户名" prop="username">
              <el-input
                size="small"
                v-model="editForm.username"
                auto-complete="off"
                placeholder="请输入用户名"
              ></el-input>
            </el-form-item>
          </el-col>
          <el-col :span="12">
            <el-form-item label="密码" prop="password">
              <el-input
                size="small"
                v-model="editForm.password"
                auto-complete="off"
                placeholder="请输入密码"
              ></el-input>
            </el-form-item>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="12">
            <el-form-item label="预计使用存储量" prop="roleNo1">
              <el-input
              type="number"
                size="small"
                v-model="editForm.roleNo1"
                auto-complete="off"
                placeholder="请输入预计使用存储量"
              ></el-input>
            </el-form-item>
          </el-col>
          <el-col :span="12">
            <el-form-item label="附件" prop="roleNo2">
              <el-input readonly v-model="fileName" size="small"></el-input>
              <el-upload
                action="#"
                ref="upload"
                :file-list="fileList"
                :auto-upload="false"
              >
                <el-button slot="trigger" size="small" type="primary"
                  >选择文件</el-button
                >
              </el-upload>
            </el-form-item>
          </el-col>
        </el-row>
      </el-form>
      <div slot="footer" class="dialog-footer">
        <el-button size="small" @click="closeDialog('edit')">取消</el-button>
        <el-button
          size="small"
          type="primary"
          :loading="loading"
          class="title"
          @click="submitForm('editForm')"
          >保存</el-button
        >
      </div>
    </el-dialog>
    <!-- 申请数据库列表弹窗 -->
    <el-dialog
      title="选择数据源类型"
      :visible.sync="editFormVisibleDataType"
      width="60%"
      @click="closeDialog('edit')"
    >
      <!-- 数据源列表 -->
      <ul class="DataSourceType">
        <li
          v-for="(item, index) in dataSourceList"
          :key="index"
          @mouseover="showImage(index)"
          @mouseout="hideImage(index)"
          @click="toggleImage(index)"
          :class="{ active: activeIndex === index }"
        >
          <div class="dataSourceImg">
            <img
              :src="item.showImage1 ? item.imageUrl1 : item.imageUrl2"
              alt=""
            />
          </div>
          <span class="dataSourceSpan">{{ item.text }}</span>
        </li>
      </ul>
      <div slot="footer" class="dialog-footer">
        <el-button size="small" @click="closeDialog('edit')">取消</el-button>
        <el-button
          size="small"
          type="primary"
          :loading="loading"
          class="title"
          @click="submitFormDataSourceType()"
          >确定</el-button
        >
      </div>
    </el-dialog>
  </div>
</template>

<script>
import {
  roleList,
  roleSave,
  roleDelete,
  rolePwd,
  RoleRightTree,
  RoleRightSave,
} from "../../api/userMG";
import Pagination from "../../components/Pagination";
export default {
  data() {
    return {
      fileName: "",
      fileList: [],
      dataSourceList: [
        {
          imageUrl1: require("@/assets/img/dataSourceImg/mysql.png"),
          imageUrl2: require("@/assets/img/dataSourceImg/mysql_over.png"),
          showImage1: true,
          text: "数据库",
        },
        {
          imageUrl1: require("@/assets/img/dataSourceImg/oceanbase.png"),
          imageUrl2: require("@/assets/img/dataSourceImg/oceanbase_over.png"),
          showImage1: true,
          text: "OceanBase for MySQL",
        },
        {
          imageUrl1: require("@/assets/img/dataSourceImg/oceanbase.png"),
          imageUrl2: require("@/assets/img/dataSourceImg/oceanbase_over.png"),
          showImage1: true,
          text: "OceanBase for Oracle",
        },
        {
          imageUrl1: require("@/assets/img/dataSourceImg/oracle.png"),
          imageUrl2: require("@/assets/img/dataSourceImg/oracle_over.png"),
          showImage1: true,
          text: "Oracle",
        },
        {
          imageUrl1: require("@/assets/img/dataSourceImg/mysql.png"),
          imageUrl2: require("@/assets/img/dataSourceImg/mysql_over.png"),
          showImage1: true,
          text: "FTP",
        },
        {
          imageUrl1: require("@/assets/img/dataSourceImg/mysql.png"),
          imageUrl2: require("@/assets/img/dataSourceImg/mysql_over.png"),
          showImage1: true,
          text: "SQLServer",
        },
        {
          imageUrl1: require("@/assets/img/dataSourceImg/mysql.png"),
          imageUrl2: require("@/assets/img/dataSourceImg/mysql_over.png"),
          showImage1: true,
          text: "DB2",
        },
        {
          imageUrl1: require("@/assets/img/dataSourceImg/mysql.png"),
          imageUrl2: require("@/assets/img/dataSourceImg/mysql_over.png"),
          showImage1: true,
          text: "MongoDB",
        },
        {
          imageUrl1: require("@/assets/img/dataSourceImg/mysql.png"),
          imageUrl2: require("@/assets/img/dataSourceImg/mysql_over.png"),
          showImage1: true,
          text: "Kafka",
        },
        {
          imageUrl1: require("@/assets/img/dataSourceImg/mysql.png"),
          imageUrl2: require("@/assets/img/dataSourceImg/mysql_over.png"),
          showImage1: true,
          text: "Zookeeper",
        },
        {
          imageUrl1: require("@/assets/img/dataSourceImg/mysql.png"),
          imageUrl2: require("@/assets/img/dataSourceImg/mysql_over.png"),
          showImage1: true,
          text: "GreenPlum",
        },
        {
          imageUrl1: require("@/assets/img/dataSourceImg/mysql.png"),
          imageUrl2: require("@/assets/img/dataSourceImg/mysql_over.png"),
          showImage1: true,
          text: "PostgreSQL",
        },
        {
          imageUrl1: require("@/assets/img/dataSourceImg/mysql.png"),
          imageUrl2: require("@/assets/img/dataSourceImg/mysql_over.png"),
          showImage1: true,
          text: "DM",
        },
        {
          imageUrl1: require("@/assets/img/dataSourceImg/mysql.png"),
          imageUrl2: require("@/assets/img/dataSourceImg/mysql_over.png"),
          showImage1: true,
          text: "Kingbase",
        },
        {
          imageUrl1: require("@/assets/img/dataSourceImg/mysql.png"),
          imageUrl2: require("@/assets/img/dataSourceImg/mysql_over.png"),
          showImage1: true,
          text: "UXDB",
        },
        {
          imageUrl1: require("@/assets/img/dataSourceImg/mysql.png"),
          imageUrl2: require("@/assets/img/dataSourceImg/mysql_over.png"),
          showImage1: true,
          text: "Gauss200",
        },
        {
          imageUrl1: require("@/assets/img/dataSourceImg/mysql.png"),
          imageUrl2: require("@/assets/img/dataSourceImg/mysql_over.png"),
          showImage1: true,
          text: "ClickHouse",
        },
        {
          imageUrl1: require("@/assets/img/dataSourceImg/mysql.png"),
          imageUrl2: require("@/assets/img/dataSourceImg/mysql_over.png"),
          showImage1: true,
          text: "OSCAR",
        },
        {
          imageUrl1: require("@/assets/img/dataSourceImg/mysql.png"),
          imageUrl2: require("@/assets/img/dataSourceImg/mysql_over.png"),
          showImage1: true,
          text: "ES",
        },
        {
          imageUrl1: require("@/assets/img/dataSourceImg/mysql.png"),
          imageUrl2: require("@/assets/img/dataSourceImg/mysql_over.png"),
          showImage1: true,
          text: "Presto",
        },
        {
          imageUrl1: require("@/assets/img/dataSourceImg/mysql.png"),
          imageUrl2: require("@/assets/img/dataSourceImg/mysql_over.png"),
          showImage1: true,
          text: "HANA",
        },
        {
          imageUrl1: require("@/assets/img/dataSourceImg/mysql.png"),
          imageUrl2: require("@/assets/img/dataSourceImg/mysql_over.png"),
          showImage1: true,
          text: "VastBase",
        },
        {
          imageUrl1: require("@/assets/img/dataSourceImg/mysql.png"),
          imageUrl2: require("@/assets/img/dataSourceImg/mysql_over.png"),
          showImage1: true,
          text: "GBase",
        },
      ], //数据源数据
      activeIndex: null,
      nshow: true, //switch开启
      fshow: false, //switch关闭
      loading: false, //是显示加载
      editFormVisible: false, //控制编辑页面显示与隐藏
      editFormVisibleDataType: false, //控制 数据源类型 显示与隐藏
      title: "添加",
      editForm: {
        requestNo: "",
        databaseType: "",
        businessSystemName: "",
        databaseName: "",
        username: "",
        password: "",
        roleNo1:"",
        token: localStorage.getItem("logintoken"),
      },
      // rules 表单验证
      rules: {
        requestNo: [
          { required: true, message: "请输入申请单号", trigger: "blur" },
        ],
        databaseType: [
          { required: true, message: "请输入申请数据类型", trigger: "blur" },
        ],
        businessSystemName: [
          { required: true, message: "请输入业务系统名称", trigger: "blur" },
        ],
        databaseName: [
          { required: true, message: "请输入数据库名称", trigger: "blur" },
        ],
        username: [
          { required: true, message: "请输入用户名", trigger: "blur" },
        ],
        password: [{ required: true, message: "请输入密码", trigger: "blur" }],
        roleNo1:[
          { required: true, message: "请输入预计使用存储量", trigger: "blur" }
        ],
        roleNo2:[
           { required: true, message: "请输入描述", trigger: "blur" }
        ]
      },
      formInline: {
        page: 1,
        limit: 10,
        varLable: "",
        varName: "",
        token: localStorage.getItem("logintoken"),
      },
      // 删除
      seletedata: {
        ids: "",
        token: localStorage.getItem("logintoken"),
      },
      userparm: [], //搜索权限
      listData: [], //用户数据
      // 数据权限
      RoleRight: [],
      RoleRightProps: {
        children: "children",
        label: "name",
      },
      // 选中
      checkmenu: [],
      //参数role
      saveroleId: "",
      // 分页参数
      pageparm: {
        currentPage: 1,
        pageSize: 10,
        total: 10,
      },
    };
  },
  // 注册组件
  components: {
    Pagination,
  },
  /**
   * 数据发生改变
   */

  watch: {},

  /**
   * 创建完毕
   */

  created() {
    this.getdata(this.formInline);
  },

  /**
   * 里面的方法只有被调用才会执行
   */

  methods: {
    showImage(index) {
      // 鼠标滑过时显示第二张图片
      this.dataSourceList[index].showImage1 = false;
    },
    hideImage(index) {
      if (!this.dataSourceList[index].showImage2) {
        // 鼠标离开时恢复显示第一张图片
        this.dataSourceList[index].showImage1 = true;
      }
    },
    toggleImage(index) {
      // 点击时切换显示第一张和第二张图片
      this.activeIndex = index;
      this.dataSourceList[index].showImage2 = true;
      //   console.log(index);
    },
    //数据源对话框确定
    submitFormDataSourceType() {
      console.log(this.activeIndex);
      if (this.activeIndex == null) {
        this.$message({
          message: "请选择数据源",
          type: "warning",
        });
      } else {
        this.editFormVisible = true; //添加弹窗
      }
    },

    // 获取角色列表
    getdata(parameter) {
      // 模拟数据
      let res = {
        code: 0,
        msg: null,
        count: 6,
        data: [
          {
            addUser: "root",
            editUser: "root",
            addTime: 1519182004000,
            editTime: 1520288426000,
            roleId: 1,
            systemNo: "pmd",
            roleNo: "Administrator",
            roleName: "超级管理员",
          },
          {
            addUser: null,
            editUser: null,
            addTime: 1521111376000,
            editTime: 1520678191000,
            roleId: 2,
            systemNo: "order",
            roleNo: "admin",
            roleName: "公司管理员",
          },
          {
            addUser: null,
            editUser: null,
            addTime: 1520678221000,
            editTime: 1520678221000,
            roleId: 95,
            systemNo: "pm",
            roleNo: "common",
            roleName: "普通用户",
          },
          {
            addUser: null,
            editUser: null,
            addTime: 1526349853000,
            editTime: 1526349853000,
            roleId: 96,
            systemNo: "1",
            roleNo: "1",
            roleName: "1",
          },
          {
            addUser: null,
            editUser: null,
            addTime: 1526349942000,
            editTime: 1526437443000,
            roleId: 97,
            systemNo: "2",
            roleNo: "2",
            roleName: "2",
          },
          {
            addUser: null,
            editUser: null,
            addTime: 1526652148000,
            editTime: 1526652148000,
            roleId: 101,
            systemNo: "test",
            roleNo: "demo",
            roleName: "演示角色",
          },
        ],
      };
      this.loading = false;
      this.listData = res.data;
      // 分页赋值
      this.pageparm.currentPage = this.formInline.page;
      this.pageparm.pageSize = this.formInline.limit;
      this.pageparm.total = res.count;
      // 模拟数据结束

      /***
       * 调用接口，注释上面模拟数据 取消下面注释
       */
      // roleList(parameter)
      //   .then(res => {
      //     this.loading = false
      //     if (res.success == false) {
      //       this.$message({
      //         type: 'info',
      //         message: res.msg
      //       })
      //     } else {
      //       this.listData = res.data
      //       // 分页赋值
      //       this.pageparm.currentPage = this.formInline.page
      //       this.pageparm.pageSize = this.formInline.limit
      //       this.pageparm.total = res.count
      //     }
      //   })
      //   .catch(err => {
      //     this.loading = false
      //     this.$message.error('获取角色列表失败，请稍后再试！')
      //   })
    },
    // 分页插件事件
    callFather(parm) {
      this.formInline.page = parm.currentPage;
      this.formInline.limit = parm.pageSize;
      this.getdata(this.formInline);
    },
    // 搜索事件
    search() {
      this.getdata(this.formInline);
    },
    //显示编辑界面
    handleEdit: function (index, row) {
      if (row != undefined && row != "undefined") {
        this.editFormVisible = true; //添加弹窗
        this.title = "修改";
        this.editForm.roleId = row.roleId;
        this.editForm.systemNo = row.systemNo;
        this.editForm.roleNo = row.roleNo;
        this.editForm.roleName = row.roleName;
      } else {
        this.editFormVisibleDataType = true; //选择数据类型对话框
        this.title = "添加";
        this.editForm.roleId = "";
        this.editForm.systemNo = "";
        this.editForm.roleNo = "";
        this.editForm.roleName = "";
      }
    },
    // 编辑、增加页面保存方法
    submitForm(editData) {
      this.$refs[editData].validate((valid) => {
        if (valid) {
          roleSave(this.editForm)
            .then((res) => {
              this.editFormVisible = false; //关闭 新增修改弹窗
              this.editFormVisibleDataType = false; //关闭 数据库类型弹窗
              this.loading = false;
              if (res.success) {
                this.getdata(this.formInline);
                this.$message({
                  type: "success",
                  message: "角色保存成功！",
                });
              } else {
                this.$message({
                  type: "info",
                  message: res.msg,
                });
              }
            })
            .catch((err) => {
              this.editFormVisible = false;
              this.editFormVisibleDataType = false;
              this.loading = false;
              this.$message.error("角色保存失败，请稍后再试！");
            });
        } else {
          return false;
        }
      });
    },
    // 删除角色
    deleteUser(index, row) {
      this.$confirm("确定要删除吗?", "信息", {
        confirmButtonText: "确定",
        cancelButtonText: "取消",
        type: "warning",
      })
        .then(() => {
          roleDelete(row.roleId)
            .then((res) => {
              if (res.success) {
                this.$message({
                  type: "success",
                  message: "角色已删除！",
                });
                this.getdata(this.formInline);
              } else {
                this.$message({
                  type: "info",
                  message: res.msg,
                });
              }
            })
            .catch((err) => {
              this.loading = false;
              this.$message.error("角色删除失败，请稍后再试！");
            });
        })
        .catch(() => {
          this.$message({
            type: "info",
            message: "已取消删除",
          });
        });
    },
    // 选中菜单
    changemenu(arr) {
      let change = [];
      for (let i = 0; i < arr.length; i++) {
        if (arr[i].checked) {
          change.push(arr[i].id);
        }
      }
      this.checkmenu = change;
    },
    // tree 递归
    changeArr(list) {
      var temptree = [],
        tree = [],
        items = [];
      for (var i in list) {
        if (!temptree[list[i].id]) {
          var trow = {
            id: list[i].id,
            pId: list[i].pId,
            name: list[i].name,
            open: list[i].open,
            checked: list[i].checked,
            children: [],
          };
          temptree[list[i].id] = trow;
          items.push(trow);
        }
        if (list[i].uid > 0) {
          temptree[list[i].id]["children"].push({
            id: list[i].id,
            pId: list[i].pId,
            name: list[i].name,
            open: list[i].open,
            checked: list[i].checked,
            children: [],
          });
        }
      }

      for (var j in items) {
        if (temptree[items[j].pId]) {
          temptree[items[j].pId]["children"].push(temptree[items[j].id]);
        } else {
          tree.push(temptree[items[j].id]);
        }
      }
      temptree = null;
      items = null;
      return tree;
    },
    // 菜单权限-保存
    menuPermSave() {
      let parm = {
        roleId: this.saveroleId,
        moduleIds: "",
      };
      let node = this.$refs.tree.getCheckedNodes();
      let moduleIds = [];
      if (node.length != 0) {
        for (let i = 0; i < node.length; i++) {
          moduleIds.push(node[i].id);
        }
        parm.moduleIds = JSON.stringify(moduleIds);
      }
      RoleRightSave(parm)
        .then((res) => {
          if (res.success) {
            this.$message({
              type: "success",
              message: "权限保存成功",
            });
            this.getdata(this.formInline);
          } else {
            this.$message({
              type: "info",
              message: res.msg,
            });
          }
        })
        .catch((err) => {
          this.loading = false;
          this.$message.error("权限保存失败，请稍后再试！");
        });
    },
    // 关闭编辑、增加弹出框
    closeDialog(dialog) {
      if (dialog == "edit") {
        this.editFormVisible = false;
        this.editFormVisibleDataType = false;
      }
    },
  },
};
</script>

<style scoped>
.user-search {
  margin-top: 20px;
}
.userRole {
  width: 100%;
}
.form-title {
  margin: 12px 0px;
  border-left: 5px solid #198ef8;
  box-sizing: border-box;
  padding: 0 10px;
}
.DataSourceType {
  list-style: none;
  display: flex;
  flex-wrap: wrap; /* 允许内容换行 */
  justify-content: flex-start; /* 让元素靠左对齐 */
}
.DataSourceType li {
  flex-basis: calc(20% - 25px); /* 设置每个 li 元素的宽度，减去 margin 间距 */
  margin-bottom: 40px; /* 图片间距 */
  text-align: center;
  margin-left: 40px;
}
/deep/ .el-dialog__body {
  /* padding: 0px 30px !important; */
  overflow-y: auto;
  overflow-x: hidden;
  max-height: calc(100vh - 350px);
}
.dataSourceImg {
  width: 130px;
  height: 130px;
  /* background-color: var(--modal-container-bg-color); */
  background: rgb(238, 238, 238);
  display: flex;
  justify-content: center; /* 水平居中 */
  align-items: center; /* 垂直居中 */
}
.dataSourceImg img {
  width: 100px;
}
.dataSourceSpan {
  color: #1d5bf5;
  font-size: 12px;
}
</style>

 